import csv
import sqlite3

connection = sqlite3.connect('../db.sqlite3')
cursor = connection.cursor()

create_table = '''
create table data_CPU
(
    Name text not null,
    ID text not null,
    PID text not null,
    Platform text not null,
    Price text,
    CoreNumbers text,
    Frequency text,
    Power text,
    Slot text,
    Performance text,
    Architecture text,
    Process text,
    RAMType text,
    constraint cpu_pk
        primary key (Name,ID,PID,Platform)
);


'''

cursor.execute(create_table)
file = open('../GetInfo/Details/CPUInfo.csv', encoding='utf-8')
contents = csv.reader(file)
insert_records = "INSERT INTO data_CPU (Name,ID,PID,Platform,Price,CoreNumbers,Frequency,Power,Slot,Performance,Architecture,Process,RAMType) " \
                 "VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?)"

cursor.executemany(insert_records, contents)
select_all = "SELECT * FROM data_CPU"
rows = cursor.execute(select_all).fetchall()
for r in rows:
    print(r)

# Committing the changes
connection.commit()
connection.close()
